package edu.bit.water.dao;

import java.util.ArrayList;
import java.util.List;

import edu.bit.water.entity.Column;
import edu.bit.water.entity.MetaQSDEsub;
import edu.bit.water.entity.MetaTI;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.dao.DuplicateKeyException;
import org.springframework.stereotype.Repository;


import edu.bit.water.entity.MetaSensor;

@Mapper
@Repository
public interface MetaSensorDao {
	List<MetaSensor> selectData(@Param("techProcessId") String techProcessId);
	Integer queryColumnId(@Param("columnId") String columnId);
	ArrayList<MetaSensor> queryMetaSensor(int company_id);
	Integer getMaxId();
	int insertMetaSensor(MetaSensor metaSensor) ;
	//int insertMetaSensor(MetaSensor metaSensor) throws DuplicateKeyException;
	int deleteMetaSensor(@Param("metaSensorId") String metaSensorId);
	int updateMetaSensor(MetaSensor MetaSensor);
	List<Column> selectColumn(@Param("techProcessId") String techProcessId);//update by wanggoudan
	List<Column> selectRealColumn(int company_id);
	int selectEnName(String enName);
	int selectCsName(String csName);
	MetaSensor getCodeByCSName(String csName);
	MetaSensor getById(@Param("metaSensorId") Integer metaSensorId);
}
